package action;

import java.util.ArrayList;
import java.util.Date;
import java.util.HashMap;
import java.util.List;

import basic.PageInfo;
import basic.QuerySet;
import basic.ResultSet;
import basic.SortInfo;
import common.BaseAction;
import common.dict.CommonDict;
import entities.TBlackaddr;
import entities.TBlackbin;
import entities.TBlackcard;
import entities.TBlackcountry;
import entities.TBlackemail;
import entities.TBlackfinger;
import entities.TBlackip;
import entities.TBlackname;
import entities.TBlackphone;
import entities.TBlackstate;
import entities.TBlackwebsite;
import entities.TWhitecard;
import entities.TWhiteip;
import interfaces.IBlackaddrService;
import interfaces.IBlackbinService;
import interfaces.IBlackcardService;
import interfaces.IBlackcountryService;
import interfaces.IBlackemailService;
import interfaces.IBlackfingerService;
import interfaces.IBlackipService;
import interfaces.IBlacknameService;
import interfaces.IBlackphoneService;
import interfaces.IBlackstateService;
import interfaces.IBlackwebsiteService;
import interfaces.IWhitecardService;
import interfaces.IWhiteipService;
import util.ParameterUtil;
import utils.DateUtil;
import utils.ExcelUtil;
import utils.StringUtil;

public class VentureAction extends BaseAction {

	private static final long serialVersionUID = 2053252004973147709L;

	private IWhiteipService whiteipService;
	private IWhitecardService whitecardService;
	private IBlackipService blackipService;
	private IBlackcardService blackcardService;
	private IBlackbinService blackbinService;
	private IBlackwebsiteService blackwebsiteService;
	private IBlackfingerService blackfingerService;
	private IBlackcountryService blackcountryService;
	private IBlackstateService blackstateService;
	private IBlacknameService blacknameService;
	private IBlackemailService blackemailService;
	private IBlackphoneService blackphoneService;
	private IBlackaddrService blackaddrService;

	private TWhiteip whiteipBean;
	private TWhitecard whitecardBean;
	private TBlackip blackipBean;
	private TBlackcard blackcardBean;
	private TBlackbin blackbinBean;
	private TBlackwebsite blackwebsiteBean;
	private TBlackfinger blackfingerBean;
	private TBlackcountry blackcountryBean;
	private TBlackstate blackstateBean;
	private TBlackname blacknameBean;
	private TBlackemail blackemailBean;
	private TBlackphone blackphoneBean;
	private TBlackaddr blackaddrBean;

	private List<TWhiteip> whiteipList;
	private List<TWhitecard> whitecardList;
	private List<TBlackip> blackipList;
	private List<TBlackcard> blackcardList;
	private List<TBlackbin> blackbinList;
	private List<TBlackwebsite> blackwebsiteList;
	private List<TBlackfinger> blackfingerList;
	private List<TBlackcountry> blackcountryList;
	private List<TBlackstate> blackstateList;
	private List<TBlackname> blacknameList;
	private List<TBlackemail> blackemailList;
	private List<TBlackphone> blackphoneList;
	private List<TBlackaddr> blackaddrList;

	private String merNo;
	private String merNos;
	private String whtNo;
	private String whtNos;
	private String whtIp;
	private String whtIps;
	private String whtCard;
	private String whtCards;
	private Date whtDate;
	private Date whtDateTop;
	private Date whtDateEnd;
	private String whtRemark;
	private String bckNo;
	private String bckNos;
	private String bckIp;
	private String bckIps;
	private String bckCard;
	private String bckCards;
	private String bckBin;
	private String bckBins;
	private String bckWebsite;
	private String bckWebsites;
	private String bckFinger;
	private String bckFingers;
	private String bckCountry;
	private String bckCountrys;
	private String bckState;
	private String bckStates;
	private String bckName;
	private String bckNames;
	private String bckEmail;
	private String bckEmails;
	private String bckPhone;
	private String bckPhones;
	private String bckAddr;
	private String bckAddrs;
	private Date bckDate;
	private Date bckDateTop;
	private Date bckDateEnd;
	private String bckRemark;

	public String editwhiteip() throws Exception {
		return SUCCESS;
	}

	public String editwhitecard() throws Exception {
		return SUCCESS;
	}

	public String editblackip() throws Exception {
		return SUCCESS;
	}

	public String editblackcard() throws Exception {
		return SUCCESS;
	}
	
	public String editblackbin() throws Exception {
		return SUCCESS;
	}

	public String editblackwebsite() throws Exception {
		return SUCCESS;
	}

	public String editblackfinger() throws Exception {
		return SUCCESS;
	}

	public String editblackcountry() throws Exception {
		return SUCCESS;
	}

	public String editblackstate() throws Exception {
		return SUCCESS;
	}

	public String editblackname() throws Exception {
		return SUCCESS;
	}

	public String editblackemail() throws Exception {
		return SUCCESS;
	}

	public String editblackphone() throws Exception {
		return SUCCESS;
	}

	public String editblackaddr() throws Exception {
		return SUCCESS;
	}
	
	
	
	
	

	public String listwhiteip() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("whtIp", whtIp);
		paramMap.put("whtDate", ParameterUtil.dateCombin(whtDateTop, whtDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "whtDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(pageIndex, pageSize));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TWhiteip> resultSet = whiteipService.search(querySet);
		whiteipList = resultSet.getResultList();
		pageInfo = resultSet.getPageInfo();
		return SUCCESS;
	}

	public String listwhitecard() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("whtCard", whtCard);
		paramMap.put("whtDate", ParameterUtil.dateCombin(whtDateTop, whtDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "whtDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(pageIndex, pageSize));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TWhitecard> resultSet = whitecardService.search(querySet);
		whitecardList = resultSet.getResultList();
		pageInfo = resultSet.getPageInfo();
		return SUCCESS;
	}

	public String listblackip() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckIp", bckIp);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(pageIndex, pageSize));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackip> resultSet = blackipService.search(querySet);
		blackipList = resultSet.getResultList();
		pageInfo = resultSet.getPageInfo();
		return SUCCESS;
	}

	public String listblackcard() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckCard", bckCard);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(pageIndex, pageSize));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackcard> resultSet = blackcardService.search(querySet);
		blackcardList = resultSet.getResultList();
		pageInfo = resultSet.getPageInfo();
		return SUCCESS;
	}
	
	public String listblackbin() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckBin", bckBin);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(pageIndex, pageSize));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackbin> resultSet = blackbinService.search(querySet);
		blackbinList = resultSet.getResultList();
		pageInfo = resultSet.getPageInfo();
		return SUCCESS;
	}

	public String listblackwebsite() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckWebsite", bckWebsite);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(pageIndex, pageSize));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackwebsite> resultSet = blackwebsiteService.search(querySet);
		blackwebsiteList = resultSet.getResultList();
		pageInfo = resultSet.getPageInfo();
		return SUCCESS;
	}

	public String listblackfinger() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckFinger", bckFinger);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(pageIndex, pageSize));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackfinger> resultSet = blackfingerService.search(querySet);
		blackfingerList = resultSet.getResultList();
		pageInfo = resultSet.getPageInfo();
		return SUCCESS;
	}

	public String listblackcountry() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckCountry", bckCountry);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(pageIndex, pageSize));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackcountry> resultSet = blackcountryService.search(querySet);
		blackcountryList = resultSet.getResultList();
		pageInfo = resultSet.getPageInfo();
		return SUCCESS;
	}

	public String listblackstate() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckState", bckState);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(pageIndex, pageSize));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackstate> resultSet = blackstateService.search(querySet);
		blackstateList = resultSet.getResultList();
		pageInfo = resultSet.getPageInfo();
		return SUCCESS;
	}

	public String listblackname() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckName", bckName);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(pageIndex, pageSize));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackname> resultSet = blacknameService.search(querySet);
		blacknameList = resultSet.getResultList();
		pageInfo = resultSet.getPageInfo();
		return SUCCESS;
	}

	public String listblackemail() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckEmail", bckEmail);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(pageIndex, pageSize));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackemail> resultSet = blackemailService.search(querySet);
		blackemailList = resultSet.getResultList();
		pageInfo = resultSet.getPageInfo();
		return SUCCESS;
	}

	public String listblackphone() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckPhone", bckPhone);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(pageIndex, pageSize));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackphone> resultSet = blackphoneService.search(querySet);
		blackphoneList = resultSet.getResultList();
		pageInfo = resultSet.getPageInfo();
		return SUCCESS;
	}

	public String listblackaddr() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckAddr", bckAddr);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(pageIndex, pageSize));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackaddr> resultSet = blackaddrService.search(querySet);
		blackaddrList = resultSet.getResultList();
		pageInfo = resultSet.getPageInfo();
		return SUCCESS;
	}

	public String savewhiteip() throws Exception {
		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		if (StringUtil.isEmpty(text)) {
			addActionError("上传列表不能为空");
			return INFO;
		}
		String[] contents = text.split("\r\n");
		if (contents.length == 0) {
			addActionError("上传的数据行数不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String[] data = contents[i].split("\\|");
			if (data.length != 2) {
				addActionError("第" + (i + 1) + "行上传的数据列数不符合格式");
				continue;
			}
			paramMap.put("whtIp", StringUtil.split(data[0]));
			if(whiteipService.contain(paramMap)){
				addActionError("第" + (i + 1) + "行上传的数据已经存在");
				continue;
			}
			whiteipBean = new TWhiteip();
			whiteipBean.setWhtNo(StringUtil.guid());
			whiteipBean.setMerNo(CommonDict.GLOBAL_MERCHANT);
			whiteipBean.setWhtIp(StringUtil.trim(data[0]));
			whiteipBean.setWhtRemark(StringUtil.trim(data[1]));
			whiteipBean.setWhtDate(new Date());
			whiteipService.persist(whiteipBean);
			addActionError("第" + (i + 1) + "行成功存储");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String savewhitecard() throws Exception {
		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		if (StringUtil.isEmpty(text)) {
			addActionError("上传列表不能为空");
			return INFO;
		}
		String[] contents = text.split("\r\n");
		if (contents.length == 0) {
			addActionError("上传的数据行数不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String[] data = contents[i].split("\\|");
			if (data.length != 2) {
				addActionError("第" + (i + 1) + "行上传的数据列数不符合格式");
				continue;
			}
			paramMap.put("whtCard", StringUtil.split(data[0]));
			if(whitecardService.contain(paramMap)){
				addActionError("第" + (i + 1) + "行上传的数据已经存在");
				continue;
			}
			whitecardBean = new TWhitecard();
			whitecardBean.setWhtNo(StringUtil.guid());
			whitecardBean.setMerNo(CommonDict.GLOBAL_MERCHANT);
			whitecardBean.setWhtCard(StringUtil.trim(data[0]));
			whitecardBean.setWhtRemark(StringUtil.trim(data[1]));
			whitecardBean.setWhtDate(new Date());
			whitecardService.persist(whitecardBean);
			addActionError("第" + (i + 1) + "行成功存储");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String saveblackip() throws Exception {
		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		if (StringUtil.isEmpty(text)) {
			addActionError("上传列表不能为空");
			return INFO;
		}
		String[] contents = text.split("\r\n");
		if (contents.length == 0) {
			addActionError("上传的数据行数不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String[] data = contents[i].split("\\|");
			if (data.length != 2) {
				addActionError("第" + (i + 1) + "行上传的数据列数不符合格式");
				continue;
			}
			paramMap.put("bckIp", StringUtil.split(data[0]));
			if(blackipService.contain(paramMap)){
				addActionError("第" + (i + 1) + "行上传的数据已经存在");
				continue;
			}
			blackipBean = new TBlackip();
			blackipBean.setBckNo(StringUtil.guid());
			blackipBean.setMerNo(CommonDict.GLOBAL_MERCHANT);
			blackipBean.setBckIp(StringUtil.trim(data[0]));
			blackipBean.setBckRemark(StringUtil.trim(data[1]));
			blackipBean.setBckDate(new Date());
			blackipService.persist(blackipBean);
			addActionError("第" + (i + 1) + "行成功存储");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String saveblackcard() throws Exception {
		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		if (StringUtil.isEmpty(text)) {
			addActionError("上传列表不能为空");
			return INFO;
		}
		String[] contents = text.split("\r\n");
		if (contents.length == 0) {
			addActionError("上传的数据行数不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String[] data = contents[i].split("\\|");
			if (data.length != 2) {
				addActionError("第" + (i + 1) + "行上传的数据列数不符合格式");
				continue;
			}
			paramMap.put("bckCard", StringUtil.split(data[0]));
			if(blackcardService.contain(paramMap)){
				addActionError("第" + (i + 1) + "行上传的数据已经存在");
				continue;
			}
			blackcardBean = new TBlackcard();
			blackcardBean.setBckNo(StringUtil.guid());
			blackcardBean.setMerNo(CommonDict.GLOBAL_MERCHANT);
			blackcardBean.setBckCard(StringUtil.trim(data[0]));
			blackcardBean.setBckRemark(StringUtil.trim(data[1]));
			blackcardBean.setBckDate(new Date());
			blackcardService.persist(blackcardBean);
			addActionError("第" + (i + 1) + "行成功存储");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}
	
	public String saveblackbin() throws Exception {
		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		if (StringUtil.isEmpty(text)) {
			addActionError("上传列表不能为空");
			return INFO;
		}
		String[] contents = text.split("\r\n");
		if (contents.length == 0) {
			addActionError("上传的数据行数不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String[] data = contents[i].split("\\|");
			if (data.length != 2) {
				addActionError("第" + (i + 1) + "行上传的数据列数不符合格式");
				continue;
			}
			paramMap.put("bckBin", StringUtil.split(data[0]));
			if(blackbinService.contain(paramMap)){
				addActionError("第" + (i + 1) + "行上传的数据已经存在");
				continue;
			}
			blackbinBean = new TBlackbin();
			blackbinBean.setBckNo(StringUtil.guid());
			blackbinBean.setMerNo(CommonDict.GLOBAL_MERCHANT);
			blackbinBean.setBckBin(StringUtil.trim(data[0]));
			blackbinBean.setBckRemark(StringUtil.trim(data[1]));
			blackbinBean.setBckDate(new Date());
			blackbinService.persist(blackbinBean);
			addActionError("第" + (i + 1) + "行成功存储");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String saveblackwebsite() throws Exception {
		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		if (StringUtil.isEmpty(text)) {
			addActionError("上传列表不能为空");
			return INFO;
		}
		String[] contents = text.split("\r\n");
		if (contents.length == 0) {
			addActionError("上传的数据行数不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String[] data = contents[i].split("\\|");
			if (data.length != 2) {
				addActionError("第" + (i + 1) + "行上传的数据列数不符合格式");
				continue;
			}
			paramMap.put("bckWebsite", StringUtil.split(data[0]));
			if(blackwebsiteService.contain(paramMap)){
				addActionError("第" + (i + 1) + "行上传的数据已经存在");
				continue;
			}
			blackwebsiteBean = new TBlackwebsite();
			blackwebsiteBean.setBckNo(StringUtil.guid());
			blackwebsiteBean.setMerNo(CommonDict.GLOBAL_MERCHANT);
			blackwebsiteBean.setBckWebsite(StringUtil.trim(data[0]));
			blackwebsiteBean.setBckRemark(StringUtil.trim(data[1]));
			blackwebsiteBean.setBckDate(new Date());
			blackwebsiteService.persist(blackwebsiteBean);
			addActionError("第" + (i + 1) + "行成功存储");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String saveblackfinger() throws Exception {
		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		if (StringUtil.isEmpty(text)) {
			addActionError("上传列表不能为空");
			return INFO;
		}
		String[] contents = text.split("\r\n");
		if (contents.length == 0) {
			addActionError("上传的数据行数不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String[] data = contents[i].split("\\|");
			if (data.length != 2) {
				addActionError("第" + (i + 1) + "行上传的数据列数不符合格式");
				continue;
			}
			paramMap.put("bckFinger", StringUtil.split(data[0]));
			if(blackfingerService.contain(paramMap)){
				addActionError("第" + (i + 1) + "行上传的数据已经存在");
				continue;
			}
			blackfingerBean = new TBlackfinger();
			blackfingerBean.setBckNo(StringUtil.guid());
			blackfingerBean.setMerNo(CommonDict.GLOBAL_MERCHANT);
			blackfingerBean.setBckFinger(StringUtil.trim(data[0]));
			blackfingerBean.setBckRemark(StringUtil.trim(data[1]));
			blackfingerBean.setBckDate(new Date());
			blackfingerService.persist(blackfingerBean);
			addActionError("第" + (i + 1) + "行成功存储");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String saveblackcountry() throws Exception {
		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		if (StringUtil.isEmpty(text)) {
			addActionError("上传列表不能为空");
			return INFO;
		}
		String[] contents = text.split("\r\n");
		if (contents.length == 0) {
			addActionError("上传的数据行数不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String[] data = contents[i].split("\\|");
			if (data.length != 2) {
				addActionError("第" + (i + 1) + "行上传的数据列数不符合格式");
				continue;
			}
			paramMap.put("bckCountry", StringUtil.split(data[0]));
			if(blackcountryService.contain(paramMap)){
				addActionError("第" + (i + 1) + "行上传的数据已经存在");
				continue;
			}
			blackcountryBean = new TBlackcountry();
			blackcountryBean.setBckNo(StringUtil.guid());
			blackcountryBean.setMerNo(CommonDict.GLOBAL_MERCHANT);
			blackcountryBean.setBckCountry(StringUtil.trim(data[0]));
			blackcountryBean.setBckRemark(StringUtil.trim(data[1]));
			blackcountryBean.setBckDate(new Date());
			blackcountryService.persist(blackcountryBean);
			addActionError("第" + (i + 1) + "行成功存储");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String saveblackstate() throws Exception {
		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		if (StringUtil.isEmpty(text)) {
			addActionError("上传列表不能为空");
			return INFO;
		}
		String[] contents = text.split("\r\n");
		if (contents.length == 0) {
			addActionError("上传的数据行数不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String[] data = contents[i].split("\\|");
			if (data.length != 2) {
				addActionError("第" + (i + 1) + "行上传的数据列数不符合格式");
				continue;
			}
			paramMap.put("bckState", StringUtil.split(data[0]));
			if(blackstateService.contain(paramMap)){
				addActionError("第" + (i + 1) + "行上传的数据已经存在");
				continue;
			}
			blackstateBean = new TBlackstate();
			blackstateBean.setBckNo(StringUtil.guid());
			blackstateBean.setMerNo(CommonDict.GLOBAL_MERCHANT);
			blackstateBean.setBckState(StringUtil.trim(data[0]));
			blackstateBean.setBckRemark(StringUtil.trim(data[1]));
			blackstateBean.setBckDate(new Date());
			blackstateService.persist(blackstateBean);
			addActionError("第" + (i + 1) + "行成功存储");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String saveblackname() throws Exception {
		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		if (StringUtil.isEmpty(text)) {
			addActionError("上传列表不能为空");
			return INFO;
		}
		String[] contents = text.split("\r\n");
		if (contents.length == 0) {
			addActionError("上传的数据行数不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String[] data = contents[i].split("\\|");
			if (data.length != 2) {
				addActionError("第" + (i + 1) + "行上传的数据列数不符合格式");
				continue;
			}
			paramMap.put("bckName", StringUtil.split(data[0]));
			if(blacknameService.contain(paramMap)){
				addActionError("第" + (i + 1) + "行上传的数据已经存在");
				continue;
			}
			blacknameBean = new TBlackname();
			blacknameBean.setBckNo(StringUtil.guid());
			blacknameBean.setMerNo(CommonDict.GLOBAL_MERCHANT);
			blacknameBean.setBckName(StringUtil.trim(data[0]));
			blacknameBean.setBckRemark(StringUtil.trim(data[1]));
			blacknameBean.setBckDate(new Date());
			blacknameService.persist(blacknameBean);
			addActionError("第" + (i + 1) + "行成功存储");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String saveblackemail() throws Exception {
		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		if (StringUtil.isEmpty(text)) {
			addActionError("上传列表不能为空");
			return INFO;
		}
		String[] contents = text.split("\r\n");
		if (contents.length == 0) {
			addActionError("上传的数据行数不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String[] data = contents[i].split("\\|");
			if (data.length != 2) {
				addActionError("第" + (i + 1) + "行上传的数据列数不符合格式");
				continue;
			}
			paramMap.put("bckEmail", StringUtil.split(data[0]));
			if(blackemailService.contain(paramMap)){
				addActionError("第" + (i + 1) + "行上传的数据已经存在");
				continue;
			}
			blackemailBean = new TBlackemail();
			blackemailBean.setBckNo(StringUtil.guid());
			blackemailBean.setMerNo(CommonDict.GLOBAL_MERCHANT);
			blackemailBean.setBckEmail(StringUtil.trim(data[0]));
			blackemailBean.setBckRemark(StringUtil.trim(data[1]));
			blackemailBean.setBckDate(new Date());
			blackemailService.persist(blackemailBean);
			addActionError("第" + (i + 1) + "行成功存储");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String saveblackphone() throws Exception {
		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		if (StringUtil.isEmpty(text)) {
			addActionError("上传列表不能为空");
			return INFO;
		}
		String[] contents = text.split("\r\n");
		if (contents.length == 0) {
			addActionError("上传的数据行数不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String[] data = contents[i].split("\\|");
			if (data.length != 2) {
				addActionError("第" + (i + 1) + "行上传的数据列数不符合格式");
				continue;
			}
			paramMap.put("bckPhone", StringUtil.split(data[0]));
			if(blackphoneService.contain(paramMap)){
				addActionError("第" + (i + 1) + "行上传的数据已经存在");
				continue;
			}
			blackphoneBean = new TBlackphone();
			blackphoneBean.setBckNo(StringUtil.guid());
			blackphoneBean.setMerNo(CommonDict.GLOBAL_MERCHANT);
			blackphoneBean.setBckPhone(StringUtil.trim(data[0]));
			blackphoneBean.setBckRemark(StringUtil.trim(data[1]));
			blackphoneBean.setBckDate(new Date());
			blackphoneService.persist(blackphoneBean);
			addActionError("第" + (i + 1) + "行成功存储");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String saveblackaddr() throws Exception {
		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		if (StringUtil.isEmpty(text)) {
			addActionError("上传列表不能为空");
			return INFO;
		}
		String[] contents = text.split("\r\n");
		if (contents.length == 0) {
			addActionError("上传的数据行数不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String[] data = contents[i].split("\\|");
			if (data.length != 2) {
				addActionError("第" + (i + 1) + "行上传的数据列数不符合格式");
				continue;
			}
			paramMap.put("bckAddr", StringUtil.split(data[0]));
			if(blackaddrService.contain(paramMap)){
				addActionError("第" + (i + 1) + "行上传的数据已经存在");
				continue;
			}
			blackaddrBean = new TBlackaddr();
			blackaddrBean.setBckNo(StringUtil.guid());
			blackaddrBean.setMerNo(CommonDict.GLOBAL_MERCHANT);
			blackaddrBean.setBckAddr(StringUtil.trim(data[0]));
			blackaddrBean.setBckRemark(StringUtil.trim(data[1]));
			blackaddrBean.setBckDate(new Date());
			blackaddrService.persist(blackaddrBean);
			addActionError("第" + (i + 1) + "行成功存储");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	
	
	
	public String movewhiteip() throws Exception {
		if (StringUtil.isEmpty(whtNos)) {
			addActionError("删除列表不能为空");
			return INFO;
		}
		String[] contents = whtNos.split(",");
		if (contents.length == 0) {
			addActionError("删除的数据不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String data = contents[i];
			if (!StringUtil.isEmpty(data)) {
				whiteipService.remove(data);
			}
			addActionError("第" + (i + 1) + "行成功删除");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String movewhitecard() throws Exception {
		if (StringUtil.isEmpty(whtNos)) {
			addActionError("删除列表不能为空");
			return INFO;
		}
		String[] contents = whtNos.split(",");
		if (contents.length == 0) {
			addActionError("删除的数据不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String data = contents[i];
			if (!StringUtil.isEmpty(data)) {
				whitecardService.remove(data);
			}
			addActionError("第" + (i + 1) + "行成功删除");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String moveblackip() throws Exception {
		if (StringUtil.isEmpty(bckNos)) {
			addActionError("删除列表不能为空");
			return INFO;
		}
		String[] contents = bckNos.split(",");
		if (contents.length == 0) {
			addActionError("删除的数据不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String data = contents[i];
			if (!StringUtil.isEmpty(data)) {
				blackipService.remove(data);
			}
			addActionError("第" + (i + 1) + "行成功删除");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String moveblackcard() throws Exception {
		if (StringUtil.isEmpty(bckNos)) {
			addActionError("删除列表不能为空");
			return INFO;
		}
		String[] contents = bckNos.split(",");
		if (contents.length == 0) {
			addActionError("删除的数据不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String data = contents[i];
			if (!StringUtil.isEmpty(data)) {
				blackcardService.remove(data);
			}
			addActionError("第" + (i + 1) + "行成功删除");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}
	
	public String moveblackbin() throws Exception {
		if (StringUtil.isEmpty(bckNos)) {
			addActionError("删除列表不能为空");
			return INFO;
		}
		String[] contents = bckNos.split(",");
		if (contents.length == 0) {
			addActionError("删除的数据不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String data = contents[i];
			if (!StringUtil.isEmpty(data)) {
				blackbinService.remove(data);
			}
			addActionError("第" + (i + 1) + "行成功删除");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String moveblackwebsite() throws Exception {
		if (StringUtil.isEmpty(bckNos)) {
			addActionError("删除列表不能为空");
			return INFO;
		}
		String[] contents = bckNos.split(",");
		if (contents.length == 0) {
			addActionError("删除的数据不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String data = contents[i];
			if (!StringUtil.isEmpty(data)) {
				blackwebsiteService.remove(data);
			}
			addActionError("第" + (i + 1) + "行成功删除");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String moveblackfinger() throws Exception {
		if (StringUtil.isEmpty(bckNos)) {
			addActionError("删除列表不能为空");
			return INFO;
		}
		String[] contents = bckNos.split(",");
		if (contents.length == 0) {
			addActionError("删除的数据不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String data = contents[i];
			if (!StringUtil.isEmpty(data)) {
				blackfingerService.remove(data);
			}
			addActionError("第" + (i + 1) + "行成功删除");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String moveblackcountry() throws Exception {
		if (StringUtil.isEmpty(bckNos)) {
			addActionError("删除列表不能为空");
			return INFO;
		}
		String[] contents = bckNos.split(",");
		if (contents.length == 0) {
			addActionError("删除的数据不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String data = contents[i];
			if (!StringUtil.isEmpty(data)) {
				blackcountryService.remove(data);
			}
			addActionError("第" + (i + 1) + "行成功删除");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String moveblackstate() throws Exception {
		if (StringUtil.isEmpty(bckNos)) {
			addActionError("删除列表不能为空");
			return INFO;
		}
		String[] contents = bckNos.split(",");
		if (contents.length == 0) {
			addActionError("删除的数据不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String data = contents[i];
			if (!StringUtil.isEmpty(data)) {
				blackstateService.remove(data);
			}
			addActionError("第" + (i + 1) + "行成功删除");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String moveblackname() throws Exception {
		if (StringUtil.isEmpty(bckNos)) {
			addActionError("删除列表不能为空");
			return INFO;
		}
		String[] contents = bckNos.split(",");
		if (contents.length == 0) {
			addActionError("删除的数据不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String data = contents[i];
			if (!StringUtil.isEmpty(data)) {
				blacknameService.remove(data);
			}
			addActionError("第" + (i + 1) + "行成功删除");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String moveblackemail() throws Exception {
		if (StringUtil.isEmpty(bckNos)) {
			addActionError("删除列表不能为空");
			return INFO;
		}
		String[] contents = bckNos.split(",");
		if (contents.length == 0) {
			addActionError("删除的数据不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String data = contents[i];
			if (!StringUtil.isEmpty(data)) {
				blackemailService.remove(data);
			}
			addActionError("第" + (i + 1) + "行成功删除");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String moveblackphone() throws Exception {
		if (StringUtil.isEmpty(bckNos)) {
			addActionError("删除列表不能为空");
			return INFO;
		}
		String[] contents = bckNos.split(",");
		if (contents.length == 0) {
			addActionError("删除的数据不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String data = contents[i];
			if (!StringUtil.isEmpty(data)) {
				blackphoneService.remove(data);
			}
			addActionError("第" + (i + 1) + "行成功删除");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String moveblackaddr() throws Exception {
		if (StringUtil.isEmpty(bckNos)) {
			addActionError("删除列表不能为空");
			return INFO;
		}
		String[] contents = bckNos.split(",");
		if (contents.length == 0) {
			addActionError("删除的数据不符合格式");
			return INFO;
		}
		int step = 0;
		for (int i = 0; i < contents.length; i++) {
			String data = contents[i];
			if (!StringUtil.isEmpty(data)) {
				blackaddrService.remove(data);
			}
			addActionError("第" + (i + 1) + "行成功删除");
			step = step + 1;
		}
		addActionError("共成功 " + step + " 条数据");
		return SUCCESS;
	}

	public String exportwhiteip() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("whtIp", whtIp);
		paramMap.put("whtDate", ParameterUtil.dateCombin(whtDateTop, whtDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "whtDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(1, CommonDict.EXPORT_LIMIT));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TWhiteip> resultSet = whiteipService.search(querySet);
		whiteipList = resultSet.getResultList();

		List<String> fieldHead = new ArrayList<String>();
		fieldHead.add("编号");
		fieldHead.add("所属商户号");
		fieldHead.add("内容");
		fieldHead.add("日期日期");
		fieldHead.add("日期时间");
		fieldHead.add("备注");

		List<List<String>> fieldData = new ArrayList<List<String>>();

		for (TWhiteip whiteipBean : whiteipList) {
			List<String> fieldItem = new ArrayList<String>();
			fieldItem.add(whiteipBean.getWhtNo());
			fieldItem.add(whiteipBean.getMerNo());
			fieldItem.add(whiteipBean.getWhtIp());
			fieldItem.add(DateUtil.format(whiteipBean.getWhtDate(), DateUtil.DATE));
			fieldItem.add(DateUtil.format(whiteipBean.getWhtDate(), DateUtil.TIME));
			fieldItem.add(whiteipBean.getWhtRemark());
			fieldData.add(fieldItem);
		}

		inputStream = ExcelUtil.excel(fieldHead, fieldData);
		return SUCCESS;
	}

	public String exportwhitecard() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("whtCard", whtCard);
		paramMap.put("whtDate", ParameterUtil.dateCombin(whtDateTop, whtDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "whtDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(1, CommonDict.EXPORT_LIMIT));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TWhitecard> resultSet = whitecardService.search(querySet);
		whitecardList = resultSet.getResultList();

		List<String> fieldHead = new ArrayList<String>();
		fieldHead.add("编号");
		fieldHead.add("所属商户号");
		fieldHead.add("内容");
		fieldHead.add("日期日期");
		fieldHead.add("日期时间");
		fieldHead.add("备注");

		List<List<String>> fieldData = new ArrayList<List<String>>();

		for (TWhitecard whitecardBean : whitecardList) {
			List<String> fieldItem = new ArrayList<String>();
			fieldItem.add(whitecardBean.getWhtNo());
			fieldItem.add(whitecardBean.getMerNo());
			fieldItem.add(whitecardBean.getWhtCard());
			fieldItem.add(DateUtil.format(whitecardBean.getWhtDate(), DateUtil.DATE));
			fieldItem.add(DateUtil.format(whitecardBean.getWhtDate(), DateUtil.TIME));
			fieldItem.add(whitecardBean.getWhtRemark());
			fieldData.add(fieldItem);
		}

		inputStream = ExcelUtil.excel(fieldHead, fieldData);
		return SUCCESS;
	}

	public String exportblackip() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckIp", bckIp);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(1, CommonDict.EXPORT_LIMIT));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackip> resultSet = blackipService.search(querySet);
		blackipList = resultSet.getResultList();

		List<String> fieldHead = new ArrayList<String>();
		fieldHead.add("编号");
		fieldHead.add("所属商户号");
		fieldHead.add("内容");
		fieldHead.add("日期日期");
		fieldHead.add("日期时间");
		fieldHead.add("备注");

		List<List<String>> fieldData = new ArrayList<List<String>>();

		for (TBlackip blackipBean : blackipList) {
			List<String> fieldItem = new ArrayList<String>();
			fieldItem.add(blackipBean.getBckNo());
			fieldItem.add(blackipBean.getMerNo());
			fieldItem.add(blackipBean.getBckIp());
			fieldItem.add(DateUtil.format(blackipBean.getBckDate(), DateUtil.DATE));
			fieldItem.add(DateUtil.format(blackipBean.getBckDate(), DateUtil.TIME));
			fieldItem.add(blackipBean.getBckRemark());
			fieldData.add(fieldItem);
		}

		inputStream = ExcelUtil.excel(fieldHead, fieldData);
		return SUCCESS;
	}

	public String exportblackcard() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckCard", bckCard);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(1, CommonDict.EXPORT_LIMIT));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackcard> resultSet = blackcardService.search(querySet);
		blackcardList = resultSet.getResultList();

		List<String> fieldHead = new ArrayList<String>();
		fieldHead.add("编号");
		fieldHead.add("所属商户号");
		fieldHead.add("内容");
		fieldHead.add("日期日期");
		fieldHead.add("日期时间");
		fieldHead.add("备注");

		List<List<String>> fieldData = new ArrayList<List<String>>();

		for (TBlackcard blackcardBean : blackcardList) {
			List<String> fieldItem = new ArrayList<String>();
			fieldItem.add(blackcardBean.getBckNo());
			fieldItem.add(blackcardBean.getMerNo());
			fieldItem.add(blackcardBean.getBckCard());
			fieldItem.add(DateUtil.format(blackcardBean.getBckDate(), DateUtil.DATE));
			fieldItem.add(DateUtil.format(blackcardBean.getBckDate(), DateUtil.TIME));
			fieldItem.add(blackcardBean.getBckRemark());
			fieldData.add(fieldItem);
		}

		inputStream = ExcelUtil.excel(fieldHead, fieldData);
		return SUCCESS;
	}
	
	public String exportblackbin() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckBin", bckBin);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(1, CommonDict.EXPORT_LIMIT));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackbin> resultSet = blackbinService.search(querySet);
		blackbinList = resultSet.getResultList();

		List<String> fieldHead = new ArrayList<String>();
		fieldHead.add("编号");
		fieldHead.add("所属商户号");
		fieldHead.add("内容");
		fieldHead.add("日期日期");
		fieldHead.add("日期时间");
		fieldHead.add("备注");

		List<List<String>> fieldData = new ArrayList<List<String>>();

		for (TBlackbin blackbinBean : blackbinList) {
			List<String> fieldItem = new ArrayList<String>();
			fieldItem.add(blackbinBean.getBckNo());
			fieldItem.add(blackbinBean.getMerNo());
			fieldItem.add(blackbinBean.getBckBin());
			fieldItem.add(DateUtil.format(blackbinBean.getBckDate(), DateUtil.DATE));
			fieldItem.add(DateUtil.format(blackbinBean.getBckDate(), DateUtil.TIME));
			fieldItem.add(blackbinBean.getBckRemark());
			fieldData.add(fieldItem);
		}

		inputStream = ExcelUtil.excel(fieldHead, fieldData);
		return SUCCESS;
	}

	public String exportblackwebsite() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckWebsite", bckWebsite);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(1, CommonDict.EXPORT_LIMIT));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackwebsite> resultSet = blackwebsiteService.search(querySet);
		blackwebsiteList = resultSet.getResultList();

		List<String> fieldHead = new ArrayList<String>();
		fieldHead.add("编号");
		fieldHead.add("所属商户号");
		fieldHead.add("内容");
		fieldHead.add("日期日期");
		fieldHead.add("日期时间");
		fieldHead.add("备注");

		List<List<String>> fieldData = new ArrayList<List<String>>();

		for (TBlackwebsite blackwebsiteBean : blackwebsiteList) {
			List<String> fieldItem = new ArrayList<String>();
			fieldItem.add(blackwebsiteBean.getBckNo());
			fieldItem.add(blackwebsiteBean.getMerNo());
			fieldItem.add(blackwebsiteBean.getBckWebsite());
			fieldItem.add(DateUtil.format(blackwebsiteBean.getBckDate(), DateUtil.DATE));
			fieldItem.add(DateUtil.format(blackwebsiteBean.getBckDate(), DateUtil.TIME));
			fieldItem.add(blackwebsiteBean.getBckRemark());
			fieldData.add(fieldItem);
		}

		inputStream = ExcelUtil.excel(fieldHead, fieldData);
		return SUCCESS;
	}

	public String exportblackfinger() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckFinger", bckFinger);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(1, CommonDict.EXPORT_LIMIT));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackfinger> resultSet = blackfingerService.search(querySet);
		blackfingerList = resultSet.getResultList();

		List<String> fieldHead = new ArrayList<String>();
		fieldHead.add("编号");
		fieldHead.add("所属商户号");
		fieldHead.add("内容");
		fieldHead.add("日期日期");
		fieldHead.add("日期时间");
		fieldHead.add("备注");

		List<List<String>> fieldData = new ArrayList<List<String>>();

		for (TBlackfinger blackfingerBean : blackfingerList) {
			List<String> fieldItem = new ArrayList<String>();
			fieldItem.add(blackfingerBean.getBckNo());
			fieldItem.add(blackfingerBean.getMerNo());
			fieldItem.add(blackfingerBean.getBckFinger());
			fieldItem.add(DateUtil.format(blackfingerBean.getBckDate(), DateUtil.DATE));
			fieldItem.add(DateUtil.format(blackfingerBean.getBckDate(), DateUtil.TIME));
			fieldItem.add(blackfingerBean.getBckRemark());
			fieldData.add(fieldItem);
		}

		inputStream = ExcelUtil.excel(fieldHead, fieldData);
		return SUCCESS;
	}

	public String exportblackcountry() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckCountry", bckCountry);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(1, CommonDict.EXPORT_LIMIT));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackcountry> resultSet = blackcountryService.search(querySet);
		blackcountryList = resultSet.getResultList();

		List<String> fieldHead = new ArrayList<String>();
		fieldHead.add("编号");
		fieldHead.add("所属商户号");
		fieldHead.add("内容");
		fieldHead.add("日期日期");
		fieldHead.add("日期时间");
		fieldHead.add("备注");

		List<List<String>> fieldData = new ArrayList<List<String>>();

		for (TBlackcountry blackcountryBean : blackcountryList) {
			List<String> fieldItem = new ArrayList<String>();
			fieldItem.add(blackcountryBean.getBckNo());
			fieldItem.add(blackcountryBean.getMerNo());
			fieldItem.add(blackcountryBean.getBckCountry());
			fieldItem.add(DateUtil.format(blackcountryBean.getBckDate(), DateUtil.DATE));
			fieldItem.add(DateUtil.format(blackcountryBean.getBckDate(), DateUtil.TIME));
			fieldItem.add(blackcountryBean.getBckRemark());
			fieldData.add(fieldItem);
		}

		inputStream = ExcelUtil.excel(fieldHead, fieldData);
		return SUCCESS;
	}

	public String exportblackstate() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckState", bckState);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(1, CommonDict.EXPORT_LIMIT));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackstate> resultSet = blackstateService.search(querySet);
		blackstateList = resultSet.getResultList();

		List<String> fieldHead = new ArrayList<String>();
		fieldHead.add("编号");
		fieldHead.add("所属商户号");
		fieldHead.add("内容");
		fieldHead.add("日期日期");
		fieldHead.add("日期时间");
		fieldHead.add("备注");

		List<List<String>> fieldData = new ArrayList<List<String>>();

		for (TBlackstate blackstateBean : blackstateList) {
			List<String> fieldItem = new ArrayList<String>();
			fieldItem.add(blackstateBean.getBckNo());
			fieldItem.add(blackstateBean.getMerNo());
			fieldItem.add(blackstateBean.getBckState());
			fieldItem.add(DateUtil.format(blackstateBean.getBckDate(), DateUtil.DATE));
			fieldItem.add(DateUtil.format(blackstateBean.getBckDate(), DateUtil.TIME));
			fieldItem.add(blackstateBean.getBckRemark());
			fieldData.add(fieldItem);
		}

		inputStream = ExcelUtil.excel(fieldHead, fieldData);
		return SUCCESS;
	}

	public String exportblackname() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckName", bckName);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(1, CommonDict.EXPORT_LIMIT));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackname> resultSet = blacknameService.search(querySet);
		blacknameList = resultSet.getResultList();

		List<String> fieldHead = new ArrayList<String>();
		fieldHead.add("编号");
		fieldHead.add("所属商户号");
		fieldHead.add("内容");
		fieldHead.add("日期日期");
		fieldHead.add("日期时间");
		fieldHead.add("备注");

		List<List<String>> fieldData = new ArrayList<List<String>>();

		for (TBlackname blacknameBean : blacknameList) {
			List<String> fieldItem = new ArrayList<String>();
			fieldItem.add(blacknameBean.getBckNo());
			fieldItem.add(blacknameBean.getMerNo());
			fieldItem.add(blacknameBean.getBckName());
			fieldItem.add(DateUtil.format(blacknameBean.getBckDate(), DateUtil.DATE));
			fieldItem.add(DateUtil.format(blacknameBean.getBckDate(), DateUtil.TIME));
			fieldItem.add(blacknameBean.getBckRemark());
			fieldData.add(fieldItem);
		}

		inputStream = ExcelUtil.excel(fieldHead, fieldData);
		return SUCCESS;
	}

	public String exportblackemail() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckEmail", bckEmail);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(1, CommonDict.EXPORT_LIMIT));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackemail> resultSet = blackemailService.search(querySet);
		blackemailList = resultSet.getResultList();

		List<String> fieldHead = new ArrayList<String>();
		fieldHead.add("编号");
		fieldHead.add("所属商户号");
		fieldHead.add("内容");
		fieldHead.add("日期日期");
		fieldHead.add("日期时间");
		fieldHead.add("备注");

		List<List<String>> fieldData = new ArrayList<List<String>>();

		for (TBlackemail blackemailBean : blackemailList) {
			List<String> fieldItem = new ArrayList<String>();
			fieldItem.add(blackemailBean.getBckNo());
			fieldItem.add(blackemailBean.getMerNo());
			fieldItem.add(blackemailBean.getBckEmail());
			fieldItem.add(DateUtil.format(blackemailBean.getBckDate(), DateUtil.DATE));
			fieldItem.add(DateUtil.format(blackemailBean.getBckDate(), DateUtil.TIME));
			fieldItem.add(blackemailBean.getBckRemark());
			fieldData.add(fieldItem);
		}

		inputStream = ExcelUtil.excel(fieldHead, fieldData);
		return SUCCESS;
	}

	public String exportblackphone() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckPhone", bckPhone);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(1, CommonDict.EXPORT_LIMIT));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackphone> resultSet = blackphoneService.search(querySet);
		blackphoneList = resultSet.getResultList();

		List<String> fieldHead = new ArrayList<String>();
		fieldHead.add("编号");
		fieldHead.add("所属商户号");
		fieldHead.add("内容");
		fieldHead.add("日期日期");
		fieldHead.add("日期时间");
		fieldHead.add("备注");

		List<List<String>> fieldData = new ArrayList<List<String>>();

		for (TBlackphone blackphoneBean : blackphoneList) {
			List<String> fieldItem = new ArrayList<String>();
			fieldItem.add(blackphoneBean.getBckNo());
			fieldItem.add(blackphoneBean.getMerNo());
			fieldItem.add(blackphoneBean.getBckPhone());
			fieldItem.add(DateUtil.format(blackphoneBean.getBckDate(), DateUtil.DATE));
			fieldItem.add(DateUtil.format(blackphoneBean.getBckDate(), DateUtil.TIME));
			fieldItem.add(blackphoneBean.getBckRemark());
			fieldData.add(fieldItem);
		}

		inputStream = ExcelUtil.excel(fieldHead, fieldData);
		return SUCCESS;
	}

	public String exportblackaddr() throws Exception {
		QuerySet<Object> querySet = new QuerySet<Object>();

		HashMap<String, Object> paramMap = new HashMap<String, Object>();
		paramMap.put("merNo", StringUtil.split(merNo));
		paramMap.put("bckAddr", bckAddr);
		paramMap.put("bckDate", ParameterUtil.dateCombin(bckDateTop, bckDateEnd));

		SortInfo sortInfo = new SortInfo();
		sortInfo.setSortField((StringUtil.isEmpty(sortField)) ? "bckDate" : sortField);
		sortInfo.setSortOrder(sortOrder);

		querySet.setPageInfo(new PageInfo(1, CommonDict.EXPORT_LIMIT));
		querySet.setSortInfo(sortInfo);
		querySet.setParamMap(paramMap);

		ResultSet<TBlackaddr> resultSet = blackaddrService.search(querySet);
		blackaddrList = resultSet.getResultList();

		List<String> fieldHead = new ArrayList<String>();
		fieldHead.add("编号");
		fieldHead.add("所属商户号");
		fieldHead.add("内容");
		fieldHead.add("日期日期");
		fieldHead.add("日期时间");
		fieldHead.add("备注");

		List<List<String>> fieldData = new ArrayList<List<String>>();

		for (TBlackaddr blackaddrBean : blackaddrList) {
			List<String> fieldItem = new ArrayList<String>();
			fieldItem.add(blackaddrBean.getBckNo());
			fieldItem.add(blackaddrBean.getMerNo());
			fieldItem.add(blackaddrBean.getBckAddr());
			fieldItem.add(DateUtil.format(blackaddrBean.getBckDate(), DateUtil.DATE));
			fieldItem.add(DateUtil.format(blackaddrBean.getBckDate(), DateUtil.TIME));
			fieldItem.add(blackaddrBean.getBckRemark());
			fieldData.add(fieldItem);
		}

		inputStream = ExcelUtil.excel(fieldHead, fieldData);
		return SUCCESS;
	}

	/////////////////////////////////
	/////////////////////////////////
	/////////////////////////////////

	public IWhiteipService getWhiteipService() {
		return whiteipService;
	}

	public void setWhiteipService(IWhiteipService whiteipService) {
		this.whiteipService = whiteipService;
	}

	public IWhitecardService getWhitecardService() {
		return whitecardService;
	}

	public void setWhitecardService(IWhitecardService whitecardService) {
		this.whitecardService = whitecardService;
	}

	public IBlackipService getBlackipService() {
		return blackipService;
	}

	public void setBlackipService(IBlackipService blackipService) {
		this.blackipService = blackipService;
	}

	public IBlackcardService getBlackcardService() {
		return blackcardService;
	}

	public void setBlackcardService(IBlackcardService blackcardService) {
		this.blackcardService = blackcardService;
	}

	public IBlackbinService getBlackbinService() {
		return blackbinService;
	}

	public void setBlackbinService(IBlackbinService blackbinService) {
		this.blackbinService = blackbinService;
	}

	public IBlackwebsiteService getBlackwebsiteService() {
		return blackwebsiteService;
	}

	public void setBlackwebsiteService(IBlackwebsiteService blackwebsiteService) {
		this.blackwebsiteService = blackwebsiteService;
	}

	public IBlackfingerService getBlackfingerService() {
		return blackfingerService;
	}

	public void setBlackfingerService(IBlackfingerService blackfingerService) {
		this.blackfingerService = blackfingerService;
	}

	public IBlackcountryService getBlackcountryService() {
		return blackcountryService;
	}

	public void setBlackcountryService(IBlackcountryService blackcountryService) {
		this.blackcountryService = blackcountryService;
	}

	public IBlackstateService getBlackstateService() {
		return blackstateService;
	}

	public void setBlackstateService(IBlackstateService blackstateService) {
		this.blackstateService = blackstateService;
	}

	public IBlacknameService getBlacknameService() {
		return blacknameService;
	}

	public void setBlacknameService(IBlacknameService blacknameService) {
		this.blacknameService = blacknameService;
	}

	public IBlackemailService getBlackemailService() {
		return blackemailService;
	}

	public void setBlackemailService(IBlackemailService blackemailService) {
		this.blackemailService = blackemailService;
	}

	public IBlackphoneService getBlackphoneService() {
		return blackphoneService;
	}

	public void setBlackphoneService(IBlackphoneService blackphoneService) {
		this.blackphoneService = blackphoneService;
	}

	public IBlackaddrService getBlackaddrService() {
		return blackaddrService;
	}

	public void setBlackaddrService(IBlackaddrService blackaddrService) {
		this.blackaddrService = blackaddrService;
	}

	public TWhiteip getWhiteipBean() {
		return whiteipBean;
	}

	public void setWhiteipBean(TWhiteip whiteipBean) {
		this.whiteipBean = whiteipBean;
	}

	public TWhitecard getWhitecardBean() {
		return whitecardBean;
	}

	public void setWhitecardBean(TWhitecard whitecardBean) {
		this.whitecardBean = whitecardBean;
	}

	public TBlackip getBlackipBean() {
		return blackipBean;
	}

	public void setBlackipBean(TBlackip blackipBean) {
		this.blackipBean = blackipBean;
	}

	public TBlackcard getBlackcardBean() {
		return blackcardBean;
	}

	public void setBlackcardBean(TBlackcard blackcardBean) {
		this.blackcardBean = blackcardBean;
	}

	public TBlackbin getBlackbinBean() {
		return blackbinBean;
	}

	public void setBlackbinBean(TBlackbin blackbinBean) {
		this.blackbinBean = blackbinBean;
	}

	public TBlackwebsite getBlackwebsiteBean() {
		return blackwebsiteBean;
	}

	public void setBlackwebsiteBean(TBlackwebsite blackwebsiteBean) {
		this.blackwebsiteBean = blackwebsiteBean;
	}

	public TBlackfinger getBlackfingerBean() {
		return blackfingerBean;
	}

	public void setBlackfingerBean(TBlackfinger blackfingerBean) {
		this.blackfingerBean = blackfingerBean;
	}

	public TBlackcountry getBlackcountryBean() {
		return blackcountryBean;
	}

	public void setBlackcountryBean(TBlackcountry blackcountryBean) {
		this.blackcountryBean = blackcountryBean;
	}

	public TBlackstate getBlackstateBean() {
		return blackstateBean;
	}

	public void setBlackstateBean(TBlackstate blackstateBean) {
		this.blackstateBean = blackstateBean;
	}

	public TBlackname getBlacknameBean() {
		return blacknameBean;
	}

	public void setBlacknameBean(TBlackname blacknameBean) {
		this.blacknameBean = blacknameBean;
	}

	public TBlackemail getBlackemailBean() {
		return blackemailBean;
	}

	public void setBlackemailBean(TBlackemail blackemailBean) {
		this.blackemailBean = blackemailBean;
	}

	public TBlackphone getBlackphoneBean() {
		return blackphoneBean;
	}

	public void setBlackphoneBean(TBlackphone blackphoneBean) {
		this.blackphoneBean = blackphoneBean;
	}

	public TBlackaddr getBlackaddrBean() {
		return blackaddrBean;
	}

	public void setBlackaddrBean(TBlackaddr blackaddrBean) {
		this.blackaddrBean = blackaddrBean;
	}

	public List<TWhiteip> getWhiteipList() {
		return whiteipList;
	}

	public void setWhiteipList(List<TWhiteip> whiteipList) {
		this.whiteipList = whiteipList;
	}

	public List<TWhitecard> getWhitecardList() {
		return whitecardList;
	}

	public void setWhitecardList(List<TWhitecard> whitecardList) {
		this.whitecardList = whitecardList;
	}

	public List<TBlackip> getBlackipList() {
		return blackipList;
	}

	public void setBlackipList(List<TBlackip> blackipList) {
		this.blackipList = blackipList;
	}

	public List<TBlackcard> getBlackcardList() {
		return blackcardList;
	}

	public void setBlackcardList(List<TBlackcard> blackcardList) {
		this.blackcardList = blackcardList;
	}

	public List<TBlackbin> getBlackbinList() {
		return blackbinList;
	}

	public void setBlackbinList(List<TBlackbin> blackbinList) {
		this.blackbinList = blackbinList;
	}

	public List<TBlackwebsite> getBlackwebsiteList() {
		return blackwebsiteList;
	}

	public void setBlackwebsiteList(List<TBlackwebsite> blackwebsiteList) {
		this.blackwebsiteList = blackwebsiteList;
	}

	public List<TBlackfinger> getBlackfingerList() {
		return blackfingerList;
	}

	public void setBlackfingerList(List<TBlackfinger> blackfingerList) {
		this.blackfingerList = blackfingerList;
	}

	public List<TBlackcountry> getBlackcountryList() {
		return blackcountryList;
	}

	public void setBlackcountryList(List<TBlackcountry> blackcountryList) {
		this.blackcountryList = blackcountryList;
	}

	public List<TBlackstate> getBlackstateList() {
		return blackstateList;
	}

	public void setBlackstateList(List<TBlackstate> blackstateList) {
		this.blackstateList = blackstateList;
	}

	public List<TBlackname> getBlacknameList() {
		return blacknameList;
	}

	public void setBlacknameList(List<TBlackname> blacknameList) {
		this.blacknameList = blacknameList;
	}

	public List<TBlackemail> getBlackemailList() {
		return blackemailList;
	}

	public void setBlackemailList(List<TBlackemail> blackemailList) {
		this.blackemailList = blackemailList;
	}

	public List<TBlackphone> getBlackphoneList() {
		return blackphoneList;
	}

	public void setBlackphoneList(List<TBlackphone> blackphoneList) {
		this.blackphoneList = blackphoneList;
	}

	public List<TBlackaddr> getBlackaddrList() {
		return blackaddrList;
	}

	public void setBlackaddrList(List<TBlackaddr> blackaddrList) {
		this.blackaddrList = blackaddrList;
	}

	public String getMerNo() {
		return merNo;
	}

	public void setMerNo(String merNo) {
		this.merNo = merNo;
	}

	public String getMerNos() {
		return merNos;
	}

	public void setMerNos(String merNos) {
		this.merNos = merNos;
	}

	public String getWhtNo() {
		return whtNo;
	}

	public void setWhtNo(String whtNo) {
		this.whtNo = whtNo;
	}

	public String getWhtNos() {
		return whtNos;
	}

	public void setWhtNos(String whtNos) {
		this.whtNos = whtNos;
	}

	public String getWhtIp() {
		return whtIp;
	}

	public void setWhtIp(String whtIp) {
		this.whtIp = whtIp;
	}

	public String getWhtIps() {
		return whtIps;
	}

	public void setWhtIps(String whtIps) {
		this.whtIps = whtIps;
	}

	public String getWhtCard() {
		return whtCard;
	}

	public void setWhtCard(String whtCard) {
		this.whtCard = whtCard;
	}

	public String getWhtCards() {
		return whtCards;
	}

	public void setWhtCards(String whtCards) {
		this.whtCards = whtCards;
	}

	public Date getWhtDate() {
		return whtDate;
	}

	public void setWhtDate(Date whtDate) {
		this.whtDate = whtDate;
	}

	public Date getWhtDateTop() {
		return whtDateTop;
	}

	public void setWhtDateTop(Date whtDateTop) {
		this.whtDateTop = whtDateTop;
	}

	public Date getWhtDateEnd() {
		return whtDateEnd;
	}

	public void setWhtDateEnd(Date whtDateEnd) {
		this.whtDateEnd = whtDateEnd;
	}

	public String getWhtRemark() {
		return whtRemark;
	}

	public void setWhtRemark(String whtRemark) {
		this.whtRemark = whtRemark;
	}

	public String getBckNo() {
		return bckNo;
	}

	public void setBckNo(String bckNo) {
		this.bckNo = bckNo;
	}

	public String getBckNos() {
		return bckNos;
	}

	public void setBckNos(String bckNos) {
		this.bckNos = bckNos;
	}

	public String getBckIp() {
		return bckIp;
	}

	public void setBckIp(String bckIp) {
		this.bckIp = bckIp;
	}

	public String getBckIps() {
		return bckIps;
	}

	public void setBckIps(String bckIps) {
		this.bckIps = bckIps;
	}

	public String getBckCard() {
		return bckCard;
	}

	public void setBckCard(String bckCard) {
		this.bckCard = bckCard;
	}

	public String getBckCards() {
		return bckCards;
	}

	public void setBckCards(String bckCards) {
		this.bckCards = bckCards;
	}

	public String getBckBin() {
		return bckBin;
	}

	public void setBckBin(String bckBin) {
		this.bckBin = bckBin;
	}

	public String getBckBins() {
		return bckBins;
	}

	public void setBckBins(String bckBins) {
		this.bckBins = bckBins;
	}

	public String getBckWebsite() {
		return bckWebsite;
	}

	public void setBckWebsite(String bckWebsite) {
		this.bckWebsite = bckWebsite;
	}

	public String getBckWebsites() {
		return bckWebsites;
	}

	public void setBckWebsites(String bckWebsites) {
		this.bckWebsites = bckWebsites;
	}

	public String getBckFinger() {
		return bckFinger;
	}

	public void setBckFinger(String bckFinger) {
		this.bckFinger = bckFinger;
	}

	public String getBckFingers() {
		return bckFingers;
	}

	public void setBckFingers(String bckFingers) {
		this.bckFingers = bckFingers;
	}

	public String getBckCountry() {
		return bckCountry;
	}

	public void setBckCountry(String bckCountry) {
		this.bckCountry = bckCountry;
	}

	public String getBckCountrys() {
		return bckCountrys;
	}

	public void setBckCountrys(String bckCountrys) {
		this.bckCountrys = bckCountrys;
	}

	public String getBckState() {
		return bckState;
	}

	public void setBckState(String bckState) {
		this.bckState = bckState;
	}

	public String getBckStates() {
		return bckStates;
	}

	public void setBckStates(String bckStates) {
		this.bckStates = bckStates;
	}

	public String getBckName() {
		return bckName;
	}

	public void setBckName(String bckName) {
		this.bckName = bckName;
	}

	public String getBckNames() {
		return bckNames;
	}

	public void setBckNames(String bckNames) {
		this.bckNames = bckNames;
	}

	public String getBckEmail() {
		return bckEmail;
	}

	public void setBckEmail(String bckEmail) {
		this.bckEmail = bckEmail;
	}

	public String getBckEmails() {
		return bckEmails;
	}

	public void setBckEmails(String bckEmails) {
		this.bckEmails = bckEmails;
	}

	public String getBckPhone() {
		return bckPhone;
	}

	public void setBckPhone(String bckPhone) {
		this.bckPhone = bckPhone;
	}

	public String getBckPhones() {
		return bckPhones;
	}

	public void setBckPhones(String bckPhones) {
		this.bckPhones = bckPhones;
	}

	public String getBckAddr() {
		return bckAddr;
	}

	public void setBckAddr(String bckAddr) {
		this.bckAddr = bckAddr;
	}

	public String getBckAddrs() {
		return bckAddrs;
	}

	public void setBckAddrs(String bckAddrs) {
		this.bckAddrs = bckAddrs;
	}

	public Date getBckDate() {
		return bckDate;
	}

	public void setBckDate(Date bckDate) {
		this.bckDate = bckDate;
	}

	public Date getBckDateTop() {
		return bckDateTop;
	}

	public void setBckDateTop(Date bckDateTop) {
		this.bckDateTop = bckDateTop;
	}

	public Date getBckDateEnd() {
		return bckDateEnd;
	}

	public void setBckDateEnd(Date bckDateEnd) {
		this.bckDateEnd = bckDateEnd;
	}

	public String getBckRemark() {
		return bckRemark;
	}

	public void setBckRemark(String bckRemark) {
		this.bckRemark = bckRemark;
	}

}
